﻿CREATE TABLE [dbo].[ArticulosExistencias] (
    [IdArticuloExistencia] INT IDENTITY (1, 1) NOT NULL,
    [IdArticulo]           INT NOT NULL,
    [IdUbicacion]          INT NOT NULL,
    [Cantidad]             INT NOT NULL,
    [EstaEliminado]        BIT CONSTRAINT [DF_ArticulosExistencias_EstaEliminado] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_ArticulosExistencias] PRIMARY KEY CLUSTERED ([IdArticuloExistencia] ASC),
    CONSTRAINT [FK_ArticulosExistencias_Articulos] FOREIGN KEY ([IdArticulo]) REFERENCES [dbo].[Articulos] ([IdArticulo]),
    CONSTRAINT [FK_ArticulosExistencias_Ubicaciones] FOREIGN KEY ([IdUbicacion]) REFERENCES [dbo].[Ubicaciones] ([IdUbicacion])
);





